﻿using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using QLTH_DTO;

namespace QLTH_DATASSECC
{
   public class clsHocViDA : ConnectionData.clsKetNoi
    {
       String _sql;
     
       public DataTable DanhSachHocVi() 
       {
           _sql = "SELECT MAHV,TENHOCVI FROM HOCVI";
           return Load_DataTable(_sql);
       }

       public string Laymahv(String _dk)
       {
           _sql = "SELECT MAHV FROM HOCVI WHERE TENHOCVI = N'"+_dk+"'";
           return laymadk(_sql).ToString();
       }
    }
}
